package com.kb.mapper.pg;

import com.kb.dto.BatchNumberDTO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface BatchNumberMapper {
//    @Select({
//            "<script>",
//            "SELECT MO.MOName AS 工单号, SO.CustomerId AS 客户编码, mo.MOQtyRequired AS 工单套数, SO.SALES_REP_NAME AS 销售人员, SO.ANALYSIS_CODE5 AS 所属行业, SO.yzsbm AS 一站式编码 " ,
//                    "FROM [WMS45].[OrBitMOM].[dbo].MO " ,
//                    "LEFT JOIN [WMS45].[OrBitMOM].[dbo].SO ON SO.SOName = LEFT(MO.MONAME, 11) " ,
//                    "WHERE MO.MOName LIKE CONCAT('%', #{keyword}, '%')",
//            "<script>"
//    })
    List<BatchNumberDTO>queryBankCard(@Param("keyword") String keyword);
}
